-- @author lixiyong01
-- @date 2024.07.09
-- host_zzdetail表

alter table hdp_lbg_supin_zplisting.raw_hism_host_zzdetail
add if not exists partition (dt='${RUNDATE}')
location 'hdfs://node101:9090/home/hdp_idea/rawdata/hism/host/raw_hism_host_zzdetail/${RUNDATE}';


alter table hdp_lbg_supin_zplisting.raw_hism_host_zzdetail
add if not exists partition (dt='20240714')
location 'hdfs://node101:9090/home/hdp_idea/rawdata/hism/host/raw_hism_host_zzdetail/20240714';
